SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Charming 4-bedroom, 3-bath farmhouse nestled on over 4 acres of open pasture and field. This inviting home blends classic character with modern updates, featuring beautiful hardwood floors, an updated kitchen with plenty of space for cooking and gathering, and comfortable living areas filled with natural light. The additional finished space over the garage offers flexibility for a guest suite, office, or recreation room. Enjoy peaceful local mountain views from the screened in porch or spend evenings by the outdoor firepit, perfect for entertaining or relaxing under the stars. With easy access to town, schools, and all amenities, this property combines the serenity of country living with everyday convenience and plenty of blueberries with over 40 bushes to pick from. Ideal for those seeking room to roam, a place for animals or gardens, and a home designed for comfort and connection. Just minutes from I89, Lebanon green and DHMC plus part of this 4 acres has direct access to the rail trail for walking and biking. Open House Saturday March 28th from 11:30-1:00pm
Description:In Town Corner Lot, sits this 4 bedroom, 2 bath Cape style home with sidewalks to Dartmouth and Main Street. The first floor has open floor plan with large living room, dinning area, 2 bedrooms and full bath. The second floor has an additional 2 bedrooms and nicely updated 3/4 bathroom and possible office space. A solid home in a great location would make a great investment or a primary residence.
Description:Located on scenic Blueberry Hill Drive with the beautiful Killington Mountain range as its backdrop, this spectacular white brick home offers lovely views from nearly every room in the home. Offering over 2,360 square feet of above-grade living space plus more than 1,500 finished square feet below grade, this spacious four-bedroom, three-bath residence provides exceptional room for both everyday living and entertaining. The dramatic living room features large windows, a striking brick fireplace, and direct access to a large Trex deck where the view takes center stage. Adjacent to the dining room, a charming glass sitting room creates the perfect place to relax and enjoy the ever-changing mountain scenery. The thoughtfully designed kitchen overlooks beautiful gardens and a stone patio and features cherry cabinetry, Corian countertops, and a comfortable eat-in counter area. Downstairs, the expansive Great Room offers a second impressive stone fireplace, bar, and wet bar, creating an ideal space for gatherings. A bright and inviting office or studio provides flexibility for remote work, hobbies, or creative pursuits. All four generously sized bedrooms are conveniently located on the same level. The primary suite enjoys its own private bath, while three additional bedrooms share a full bathroom. Practical amenities include a two-car garage and an oversized tiled mudroom with entrances from both the driveway and garage. A laundry area and additional bathroom complete this functional space. Set on 2.47 private acres, with opportunity to purchase an additional 2.16 acre parcel located directly below this home on Blueberry Hill Drive. Ideally situated 3.5 miles from the Lebanon Green, five miles from Dartmouth Hitchcock Medical Center and less than six miles from Dartmouth College this home has a wonderful location! Agent has personal interest in this property. Home is vacant and has been digitally staged in photos.
Description:Nestled on 3 private acres in Etna, NH this inviting 4-bedroom, 3-bathroom home offers picturesques water views and a peaceful New Hampshire lifestyle just minutes from Hanover. The landscaped grounds feature mature plantings, open lawn areas, and woodland surroundings that enhance the property’s privacy and charm. Start your mornings on the southeast-facing deck with a cup of coffee while listening to loons call across the water, and enjoy cozy winter days warmed by the pellet stove. Inside, you’ll find a thoughtful blend of comfort and character, including a handsome wood-paneled library, cherry kitchen cabinetry, an indoor sauna, and a newer Jacuzzi soaking tub—perfect for relaxing after a long day. The property provides both privacy and natural beauty with easy acess to Dartmouth College, Dartmouth Health, and all the amenities Hanover, NH has to offer.
Description:"The Rock Ridge Community" Built in 2020 this Colonial style home offers 4 bedroom, 3.5 bath home with extra finished living space in the full walkup basement. Open concept living with hardwood floors, granite counter tops, tiled baths and flexible floor plan. Along with ungraded finishes when purchased owners have landscaped the property with full fencing surround the lot, added a 3 season sunroom off the kitchen plus added over 700 square feet of living space with a finished basement with full bath. Share the community garden, enjoy socials at the Farmhouse, and the privileges that an HOA provides. Close to I89, DHMC, Dartmouth College, Lebanon 6 Movie Theater, Downtown and plenty of shopping. Open House Saturday July 11th 10-12